UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ri6i0qTXDmjiLsWj1BUXNrtkronmZ7k88cA9N0fcptk='
WHERE
key_id = 'cd45a322715d0235eff9b0d89504ed8fc7d043f29140ac7ce6c27ed6fff6f7f4'
AND (
token = 'Ri6i0qTXDmjiLsWj1BUXNrtkronmZ7k88cA9N0fcptk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)