UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'L0MJiuC9uYZNLNIae8cIXGbcRLWKKM94T0yX7e3HJjo='
WHERE
key_id = '59dd9696122d4d4e72a55785f105d8e07bb67d9cb25a191644f251de4cc3be9e'
AND (
token = 'L0MJiuC9uYZNLNIae8cIXGbcRLWKKM94T0yX7e3HJjo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)