UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'n02ojymxmzH+RvKP9G8x7XCLODiIhkmlTBI7u3/w4q0='
WHERE
key_id = 'f58a449553f58ad08fd704107d571a61f19e521e4deebe6f8bfc664e4a8584dd'
AND (
token = 'n02ojymxmzH+RvKP9G8x7XCLODiIhkmlTBI7u3/w4q0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)