UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7TylF0U71E+fvw6tyGBnyGW8QDNcI6GbuuCHbmYV41A='
WHERE
key_id = '0be0ba461d081c55f8560d21cc8dbb629e37bb0c50f3d4ab7851f369f0b9f0d2'
AND (
token = '7TylF0U71E+fvw6tyGBnyGW8QDNcI6GbuuCHbmYV41A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)