UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G3cOhaSuymsUsOA5gyfXVBWcEf6dCpL5qEt1xsiDDns='
WHERE
key_id = '42d8609d59f78d9dbb394a10e6b7525914b0c0781c0387308699f84429746a7e'
AND (
token = 'G3cOhaSuymsUsOA5gyfXVBWcEf6dCpL5qEt1xsiDDns='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)