UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '/qNQKvu1P1sZvek/ZFnIdSJGdRj1WUlTM5SN6GZ4RPE=' 
WHERE 
  key_id = '70e7279ab38f5b8c737a4f6c48efe0961c7f012a0fcfc8ea81a6b2b89a88be36' 
  AND (
    token = '/qNQKvu1P1sZvek/ZFnIdSJGdRj1WUlTM5SN6GZ4RPE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00025