UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8tcbwFYWcT63JnhgEN8V5LM/JTIFk3WzEWRWuFvwwIo='
WHERE
key_id = 'd988e09e2c4945fe9569e0f7a1a58c5912d9b731101f351c1dbd2af2c929ffe5'
AND (
token = '8tcbwFYWcT63JnhgEN8V5LM/JTIFk3WzEWRWuFvwwIo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)