UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VWn8LAMzC9Mid9u116vQ/qRx7emZoL1RzyTGIfdek9Q='
WHERE
key_id = 'b48097f29a40ff92b4a9fe032b640dcc45422f740d66209427e8094a6e079338'
AND (
token = 'VWn8LAMzC9Mid9u116vQ/qRx7emZoL1RzyTGIfdek9Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)