UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J4j5fDlyWm5Gyn0UTGVokMd4mrr8l2PEyay8wUsnTHs='
WHERE
key_id = '6c7207296249a41c04595b02b7b55ee2323c6863f562dc95f4d623c1336ed6a5'
AND (
token = 'J4j5fDlyWm5Gyn0UTGVokMd4mrr8l2PEyay8wUsnTHs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)