UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DoAblWE4IjdXhXEn3pZUgF0k18L6Ttz09QJ+/BOUd68='
WHERE
key_id = 'df7ea56546b7f73153bdf68477c90207772698989d50f9e70f95588bbb2920ca'
AND (
token = 'DoAblWE4IjdXhXEn3pZUgF0k18L6Ttz09QJ+/BOUd68='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)