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