UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ofbyhRx2G5to0MWcFQDjYsmzFrDB2SEEuefmsfLPcEA='
WHERE
key_id = '416fb482dd6af01ead18e5cfe1353d8a61f557041004d3023a49fc15fd30face'
AND (
token = 'ofbyhRx2G5to0MWcFQDjYsmzFrDB2SEEuefmsfLPcEA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)