UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bUbhpe7dnhrnJD0MU8DuAts9DmlYU5B5LLCd0jRx2RU='
WHERE
key_id = '3b158efb31e21e0b8e1bffc4e793c6dfbd86f7fb4f738fe1de3557ca9c450bb8'
AND (
token = 'bUbhpe7dnhrnJD0MU8DuAts9DmlYU5B5LLCd0jRx2RU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)