UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oEKCUKlRXol6ngxeL3H/L7WagXHkVVEW9HoXmPtSrXc='
WHERE
key_id = 'd62fe05a696b75b3ec606f6ed4a3ee2cb31cadd8cfd1aa373977d177ca4e1787'
AND (
token = 'oEKCUKlRXol6ngxeL3H/L7WagXHkVVEW9HoXmPtSrXc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)