UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Y6e8JcnhyzM+2fxGP3PllxQonG177K7L28X+pV4x5Bs='
WHERE
key_id = '83505b2fa40a638196e09900973a00b32145c0631fbf1a58a54d6201de62c1e2'
AND (
token = 'Y6e8JcnhyzM+2fxGP3PllxQonG177K7L28X+pV4x5Bs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)