UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XHjieQlpZfxtq3/VbYIhEaaLNtUgoFXz2vsWBOerOTo='
WHERE
key_id = '14a1fcccd639d25880442255c7bef763b735e57c4cda421b3345edf56de55ff4'
AND (
token = 'XHjieQlpZfxtq3/VbYIhEaaLNtUgoFXz2vsWBOerOTo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)