UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6F8XVyz3qNpSVtbyzhLSLq4yClP5hTBnFtkpeUyijFo='
WHERE
key_id = 'b5b193ca25794ae89a49c1f8b790e02897afe0674841e88ac1e3a18d7b5a766f'
AND (
token = '6F8XVyz3qNpSVtbyzhLSLq4yClP5hTBnFtkpeUyijFo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)