UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xiOYnnPYNhmNHWGHK1H360wt7HsbWQDIbDpEy6tnm84='
WHERE
key_id = '8e3a7495d748a659dad70605a222e28868ade0f10d269b4d66f6ffce4b3f9291'
AND (
token = 'xiOYnnPYNhmNHWGHK1H360wt7HsbWQDIbDpEy6tnm84='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)