UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mB8KRZRmmWHmnewNTAhPUnZ8mNhktH7Nj8IyRovOV84='
WHERE
key_id = 'f49e0891e21173795a10098e3d6ddaf75962e8efd23aabb092c0d77a3a3b7d6b'
AND (
token = 'mB8KRZRmmWHmnewNTAhPUnZ8mNhktH7Nj8IyRovOV84='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)