UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NRIRhwN6EE57VZ4ynXWp5ZL6wdHXqzFA15pzGA7j0t0='
WHERE
key_id = '1bcbb982de2bc1ff76599e298b493558af05f57befee01d8b682f53ef4796ec0'
AND (
token = 'NRIRhwN6EE57VZ4ynXWp5ZL6wdHXqzFA15pzGA7j0t0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)