UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oFx798a6zQcl/qVqWMplu7z1Uoq8O/YyEuBRwx1Jgns='
WHERE
key_id = '500a033377df05343cceb1de6478c6c9d96211bc0efbd43b99ddcf6e9d59767a'
AND (
token = 'oFx798a6zQcl/qVqWMplu7z1Uoq8O/YyEuBRwx1Jgns='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)