UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6AsSCNlxfD/PMlCAIopQuG3NqCbmPD+3tUED/I9PAug='
WHERE
key_id = '7e1cbc5f0aabbec953cc228677d23c59a63b342997ea3961cd7353d55a74db56'
AND (
token = '6AsSCNlxfD/PMlCAIopQuG3NqCbmPD+3tUED/I9PAug='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)