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