UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LS68mmLiB4oz2pmzl9XN3jY15k12fjDbP1kyVwyeoKM='
WHERE
key_id = '223eef0c187be03953a2698878108dc48886f556ebec603c621358fd1ae5997e'
AND (
token = 'LS68mmLiB4oz2pmzl9XN3jY15k12fjDbP1kyVwyeoKM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)