UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GvMIvmTZAXYPRNw2DbZYdFnnETZd5wLzvWh1isHV1ak='
WHERE
key_id = 'e98de8da604b1b576f62414cb7b95f3236e49366895146c727708e8962263733'
AND (
token = 'GvMIvmTZAXYPRNw2DbZYdFnnETZd5wLzvWh1isHV1ak='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)