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