UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4iZ4ZTgAwKR7YK/xY4E/eVoKXEM8SbKaT+jE7RTK6N0='
WHERE
key_id = '1a764f64a756c92aa2cff4bfe3f2ead969b4ece60682ddc305fe48b26ffbed3a'
AND (
token = '4iZ4ZTgAwKR7YK/xY4E/eVoKXEM8SbKaT+jE7RTK6N0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)