UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C8PhBLbzWgni8zAIOnzSXIxA8AXLRtlqULnyjw2czKs='
WHERE
key_id = '3ebc90c96572b363f7e9fec5a27902362b6f816e66b0a6d31ddc68fd3ea9d618'
AND (
token = 'C8PhBLbzWgni8zAIOnzSXIxA8AXLRtlqULnyjw2czKs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)